from utils.database import db

class Account(db.Model):
    __tablename__ = 'accounts'
    
    id = db.Column(db.Integer, primary_key=True)
    account_number = db.Column(db.String(20), unique=True, nullable=False)
    balance = db.Column(db.Numeric(10, 2), default=0.00)
    account_type = db.Column(db.String(20))
    user_id = db.Column(db.Integer, db.ForeignKey('userinfo.customer_id'))